DEPARTAMENTO

"192.168.0.1:sipop"

DEPARTAMENTO

Descriptions

DEPARTAMENTO DE UN PAIS

Fields

Name	Data type	Description
ID_DEPTO	CHAR (3)	ID de la tabla departamento
ID_PAIS	CHAR (3)	ID de la tabla pais, es la llave foranea que establece la relacion
NOMBRE_DEPTO	CHAR (30)	Nombre del departamento

Triggers

There are no triggers for table DEPARTAMENTO

Indices

There are no indices for table DEPARTAMENTO

References

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
PAIS	INTEG_248	ID_PAIS	ID_PAIS	RESTRICT	RESTRICT

Referenced

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
MUNICIPIOCIUDAD	FK_MUNICIPIOCIUDAD	COD_DEPARTAMENTO	ID_DEPTO	RESTRICT	RESTRICT

Definition


CREATE TABLE DEPARTAMENTO (
    ID_DEPTO CHAR (3) CHARACTER SET NONE NOT NULL COLLATE NONE,
    ID_PAIS CHAR (3) CHARACTER SET NONE NOT NULL COLLATE NONE,
    NOMBRE_DEPTO CHAR (30) CHARACTER SET NONE COLLATE NONE);

ALTER TABLE DEPARTAMENTO ADD PRIMARY KEY (ID_DEPTO);
ALTER TABLE DEPARTAMENTO ADD  FOREIGN KEY (ID_PAIS) REFERENCES PAIS (ID_PAIS);

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m.